home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / vmrreconcile.sql < prev    next >
Text File  |  2000-05-12  |  911b  |  29 lines
  1. CREATE OR REPLACE VIEW VMRRECONCILE AS SELECT
  2. MRPEND.subbatch_seq,
  3. MRPEND.prpend_indx,
  4. SUBBATCH.coin_one pennies,
  5. SUBBATCH.coin_two nickels,
  6. SUBBATCH.coin_three dimes,
  7. SUBBATCH.coin_four quarters,
  8. SUBBATCH.coin_five half_dollars,
  9. SUBBATCH.coin_six dollar_coin,
  10. SUBBATCH.coin_total_value,
  11. SUBBATCH.coin_seven * 100 sm_tokens,
  12. SUBBATCH.coin_eight * 100 lg_tokens,
  13. SUBBATCH.bill_one ones,
  14. SUBBATCH.bill_two fives,
  15. SUBBATCH.bill_three tens,
  16. SUBBATCH.bill_four twenties,
  17. SUBBATCH.receipt_total bill_total,
  18. SUBBATCH.grand_total,
  19. SUBBATCH.label_c orig_cashbox_glid,
  20. CASHBOXTOTALS.count_date,
  21. CASHBOXTOTALS.cashbox_glid,
  22. CASHBOXTOTALS.coin_total adj_coin_total,
  23. CASHBOXTOTALS.bill_total adj_bill_total,
  24. CASHBOXTOTALS.grand_total adj_grand_total
  25. FROM MRPEND, SUBBATCH, CASHBOXTOTALS
  26. WHERE
  27. SUBBATCH.subbatch_seq = MRPEND.subbatch_seq AND
  28. CASHBOXTOTALS.cashbox_total_seq = MRPEND.subbatch_seq;
  29.